package edu.zut.cs.network.merhandise.goods.service;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.SQLException;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

import edu.zut.cs.network.merhandise.base.service.BaseManager;
import edu.zut.cs.network.merhandise.goods.entity.Merhandise;
//将excel表的内容导入到数据库以及将数据库的内容导出到excel表是不是写在这里，还是增删改查里？
public interface MerhandiseManager extends BaseManager<Long, Merhandise>{
	
	void leadingIn(String fileName) throws InvalidFormatException, FileNotFoundException;
		
	void leadingOut() throws FileNotFoundException, IOException, SQLException;
	
	void create(Merhandise merhandise);
	
	int remove(Merhandise merhandise);
	
	void update(Merhandise merhandise) throws SQLException;

	Merhandise findById(Long id);
	
	Merhandise findByName(String name);
	
}
